UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W6E3+JiAN0Lln2BiirB7u2THOB7sEYyKWWUrt8rz9YI='
WHERE
key_id = 'cf420cc80776a11016a2b69f5e8b186cd38db6fe15cfa8e60ffd379126a196cd'
AND (
token = 'W6E3+JiAN0Lln2BiirB7u2THOB7sEYyKWWUrt8rz9YI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)