UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3lZSwhYy2kKLVKLPQEOL/ZoN1Aajhn8dumOHriEj7bA='
WHERE
key_id = 'd2ec225a335e784db53b81e7e705357f6d76a35b501aacead1dfa6f19e81743b'
AND (
token = '3lZSwhYy2kKLVKLPQEOL/ZoN1Aajhn8dumOHriEj7bA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)