UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DEzlZY+1wIwBTqKpRS7cICcSpjyPf1NSlPv9l/Lsz20='
WHERE
key_id = 'c286b3100552724787c756b1180eadb4434f235bc9aa0785bb779a10a727e79b'
AND (
token = 'DEzlZY+1wIwBTqKpRS7cICcSpjyPf1NSlPv9l/Lsz20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)