UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5syVcqi7q8FzsedyIH9NBcj1PDb7HzKmycGEq14N/xQ='
WHERE
key_id = '12c977948a09f716cf62e1d40b190e75348931e63a2701866e4b788a96209f28'
AND (
token = '5syVcqi7q8FzsedyIH9NBcj1PDb7HzKmycGEq14N/xQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)