UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6G5U0Ob9FDldcA8I8yXfxhcdHXr1YBeRvi6WGeJcS0Q='
WHERE
key_id = 'a86f64cbfe6a242d8d0e6b63bddfbb8f315217ea8b2052c375b01029c73d19db'
AND (
token = '6G5U0Ob9FDldcA8I8yXfxhcdHXr1YBeRvi6WGeJcS0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)