UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MCmptsIfPKh0KZsJjB4wPjqr2t7l9XJ90fxLRPYWXjE='
WHERE
key_id = '9a4814aa93fa540428ba28cebf99a3a2b3df2d1ea67d2a8a7fed1de391b72283'
AND (
token = 'MCmptsIfPKh0KZsJjB4wPjqr2t7l9XJ90fxLRPYWXjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)