UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9LDxLZrX80cuP6sgxASl/UMemfOLy/Mz7/QKO2B7K8='
WHERE
key_id = '9fc48c3e6e118843bbc0161beab9108bf983daaf64aa0176403e119cd1fed0c6'
AND (
token = 'x9LDxLZrX80cuP6sgxASl/UMemfOLy/Mz7/QKO2B7K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)