UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jvg+lhM4CGMXo9TXa92K5E45yf9Am7JSL8M8pEkBYPc='
WHERE
key_id = '53e3da01938f25e13b2509b9325f87bf8a82df850de3f909c44265696fe199ea'
AND (
token = 'jvg+lhM4CGMXo9TXa92K5E45yf9Am7JSL8M8pEkBYPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)