UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bKhkwBrD0s1bXgeFZ2sfu0CPsFRemeGNIAC1GZ6n6bk='
WHERE
key_id = '2267f959f2c6f52a8fe5764046cae149096c35930521a8e1736fc28b1c6be168'
AND (
token = 'bKhkwBrD0s1bXgeFZ2sfu0CPsFRemeGNIAC1GZ6n6bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)