UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6XHhA4/xfAsZZ0Z7j8oKkfYHjIuKXrB0FhP1eKvafg='
WHERE
key_id = 'a1c4eab2f10513310848174c2582905e5a6db8554c8edf75a3f7536c19bdbe47'
AND (
token = 'x6XHhA4/xfAsZZ0Z7j8oKkfYHjIuKXrB0FhP1eKvafg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)