UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Fc29f75S5JLopXWymGylxnz67mnaTyicA37EbvlOQrE='
WHERE
key_id = '2a43ae0e63ad385f16b4dd7d23db4028d33e58deaed0e81872700dad2230b160'
AND (
token = 'Fc29f75S5JLopXWymGylxnz67mnaTyicA37EbvlOQrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)