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