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