UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GdllRJZE04hw6lg0lFpXryfRk3Li2yNZmlU3v4JmeAM='
WHERE
key_id = '1d906579b0882161d3b06fd7ab5e1f8ccf1e46ef65c41d75cb35670381391137'
AND (
token = 'GdllRJZE04hw6lg0lFpXryfRk3Li2yNZmlU3v4JmeAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)