UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fYxn3qlwLXa1bh8GwcWFcElqv6AYbzHnD/o1ZyMJfZM='
WHERE
key_id = 'd8db0aa1ba22c6341c42ca137af7eb4e184e779c73b71c79e9d663c684255b45'
AND (
token = 'fYxn3qlwLXa1bh8GwcWFcElqv6AYbzHnD/o1ZyMJfZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)