UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1Zlh7jBtLOEEQN+rm1QoK/P7+VEPwOkv2kPjzSPfSg='
WHERE
key_id = 'a4df36f199c7fb2dccc230568384af7cf4472d2c985d542f29583357afa65043'
AND (
token = 'x1Zlh7jBtLOEEQN+rm1QoK/P7+VEPwOkv2kPjzSPfSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)