UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uxUfoSHhZ3zcYlgJTThgBN7HDGQOnb4J1avizh93O1k='
WHERE
key_id = 'ccdb2bb8a164b4f44b8f5100cbf5726c7e2be0b5f68b472246fdc7934c243b10'
AND (
token = 'uxUfoSHhZ3zcYlgJTThgBN7HDGQOnb4J1avizh93O1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)