UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1kftIYaB0OAoQq/35q9Qd7iQ9KdXjL9DCVUZx8t1YLk='
WHERE
key_id = '7fd5ee2b1ce264265feaec75749bc5380ab60f04f3e64f4457791b93891b1602'
AND (
token = '1kftIYaB0OAoQq/35q9Qd7iQ9KdXjL9DCVUZx8t1YLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)