UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dEAf0+Yvg1sDft/CtsoG/+PPs9OSZOg7Y5W+iR66XYE='
WHERE
key_id = '542140c2e423cf1ca2a43703f226581efe736a0d33595d8292be55d361e86eef'
AND (
token = 'dEAf0+Yvg1sDft/CtsoG/+PPs9OSZOg7Y5W+iR66XYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)