UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aN1Eqqro4lGby2XxJM5CWGUNPpbs9nvIRmSFGmuyVS8='
WHERE
key_id = '55cb050ccbf132033f2438cb2cb3f60f87a825582b6fc5d35c024003090163e2'
AND (
token = 'aN1Eqqro4lGby2XxJM5CWGUNPpbs9nvIRmSFGmuyVS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)