UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lnB7iRV19HGYrWfdCSDmwVKKFl46ekwFOue+tWbPdgM='
WHERE
key_id = 'a14d4010a32401048b0d265664a185de09abe0fe3d0f85c7edc8f498295ae495'
AND (
token = 'lnB7iRV19HGYrWfdCSDmwVKKFl46ekwFOue+tWbPdgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)