UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WGtMi2H/dEfEs0GIx+XBOsAu8NxanAbaO6b1ySpxhgI='
WHERE
key_id = 'dc482b565d2df6ed8298a5fbe59116bd1329756b6589bef188f1c14c727b6288'
AND (
token = 'WGtMi2H/dEfEs0GIx+XBOsAu8NxanAbaO6b1ySpxhgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)