UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v77Q9pu4i2z7VA9V3busd6SLV51nmvt59XHpi67yvE0='
WHERE
key_id = '8c67fd12a9b881d91b3ae06a7ff51381716de23c0cbd77d2a5857867846c4c9f'
AND (
token = 'v77Q9pu4i2z7VA9V3busd6SLV51nmvt59XHpi67yvE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)