UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gzoJhRh2dgJkXje37TS4P67i9twLpZ8ikah+ec0mVUA='
WHERE
key_id = '206915b9c999a6f877b8210542e6cf73b83da8a57bc515a1eb395d5a9c96dd47'
AND (
token = 'gzoJhRh2dgJkXje37TS4P67i9twLpZ8ikah+ec0mVUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)