UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yeAjg3D1uN1ZJnnyw8EK6wJ6g3jzVw1gEivWqXHT8M8='
WHERE
key_id = 'a84a1b47aceaeef5dd0b63a71c9e6acf058e13559a7f1c41eb81700c973eac5f'
AND (
token = 'yeAjg3D1uN1ZJnnyw8EK6wJ6g3jzVw1gEivWqXHT8M8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)