UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R3pe4wG1prFSvFeCiT5dx1b0HCZyq67qvRSLTo3TVhA='
WHERE
key_id = '354597bc6a41f98918903c16a390b3c52e19fba97c6909c244a4c6c605b1a2cc'
AND (
token = 'R3pe4wG1prFSvFeCiT5dx1b0HCZyq67qvRSLTo3TVhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)