UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dCk3XJVVyNwFkYADukgopPGYYmhlYYaQXjcSgSsiXz8='
WHERE
key_id = 'e129e9299f8e5c46caa71473c755c087fa29e8c347b2312002217c4b820365d6'
AND (
token = 'dCk3XJVVyNwFkYADukgopPGYYmhlYYaQXjcSgSsiXz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)