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