UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dRdfm1dW7uGMTz3qiBIgF/YUbJTgJ02tCA7hJ3tkeGw='
WHERE
key_id = 'ea336dcab439a7bdb5e2b96b00ecfe1da622831fce1471f756e691f46583757f'
AND (
token = 'dRdfm1dW7uGMTz3qiBIgF/YUbJTgJ02tCA7hJ3tkeGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)