UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R1nqnCNntvNWzd/rOAXEj6phAKVuNE4wbsKMzAwSqG4='
WHERE
key_id = '8543d19feb7d9cf9f86df2283c5f83a74fccb84aef7cfa54b471aa69c4df9fcc'
AND (
token = 'R1nqnCNntvNWzd/rOAXEj6phAKVuNE4wbsKMzAwSqG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)