UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y39ZIoj0drRJUCNAl5ixZ1ZhWHSny38Ksv2ab5S2yFs='
WHERE
key_id = '1572a6196cd26767fc046b5aad9ddc56fc6a1e463b025b3af1baea098aff1b80'
AND (
token = 'Y39ZIoj0drRJUCNAl5ixZ1ZhWHSny38Ksv2ab5S2yFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)