UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgbjqBUDLshskkPE84MCJpdM15e8MfBWkVERrzDBLO8='
WHERE
key_id = '4b2865ab62a2a1c3db558d5160cf1bbdc45354d8311a63be3b8fc7c578e9302d'
AND (
token = 'sgbjqBUDLshskkPE84MCJpdM15e8MfBWkVERrzDBLO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)