UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVG+iYhxp74XfMpdgv31zKuEm6TC2BOFTmXqJSOSGRo='
WHERE
key_id = '5837462df76a5806b492e3fa39a265aa6d4a9a04a5cdacd35964ee58da56221d'
AND (
token = 'ZVG+iYhxp74XfMpdgv31zKuEm6TC2BOFTmXqJSOSGRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)