UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cd6R4mWve8xpesgvwUA6zb+ndpKWXoXc+k0AmnWwXHw='
WHERE
key_id = 'e731374541470969f2ecc6b54c2b675e1ff3b9c34eeb321f9fd3c0e092fea5a6'
AND (
token = 'cd6R4mWve8xpesgvwUA6zb+ndpKWXoXc+k0AmnWwXHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)