UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V4gbcGDY6aa6H0IySd51eBJUmXW+8x8FRv+PgV8xcUU='
WHERE
key_id = '40eaa4f6daedf08945e21d2b01b324d04b8b75bfa40c0300ad5ca34c2ab23bc1'
AND (
token = 'V4gbcGDY6aa6H0IySd51eBJUmXW+8x8FRv+PgV8xcUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)