UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTRmim86z2a1zbIUtky15ErltQXbfng4gCteN5TbiYA='
WHERE
key_id = '0e25e74c37365cad14cb1900e6dfef8009c1d5226173f7f18af9948f19e9c606'
AND (
token = 'ZTRmim86z2a1zbIUtky15ErltQXbfng4gCteN5TbiYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)